Skip to main content

Import CSV File

Overview


Imports a CSV from file

Input

Read CSV From File

NameRequiredDescription
File PathThe full path to the file

Advanced

NameRequiredDescription
Has Header RowWhether or not the CSV has a header row
File EncodingThe encoding of the CSV file you wish to read (e.g. UTF-8, ASCII)
Delimiter CharacterThe character that separates each field in the CSV (e.g. ,)
Encapsulation CharacterThe character that surrounds each field in the CSV (e.g. ")
Optional FieldsAllows missing fields to be treated as empty. This can be used when the file does not have consistent row lengths.
Error On Bad DataIf enabled, any bad data will cause an error to be thrown. Otherwise, bad data will be ignored and the action will attempt to write all fields into the data table.
Trim WhitespaceConfigure whether fields are trimmed of whitespace. Can specify trimming the left or right of the field, both or neither

Output

Output Table The table read from the provided CSV